-
"Sort By:" at bottom of page
First of all I want to thank everyone who has been answering all of my questions. Especially Mark.
When I click on a hot column to sort, I get something like this at the bottom of the screen.
Sort By: [lngCatalogID] [36 - 40 : 40]
My problem is the "lngCatalogID" I've already used nmap to change "lngCatalogID" to "Catalog ID #"
I'd prefer not to have the actual field names visible to the user. Anyone know how to either get rid of the "Sort By:" line or to change the field name shown?
Thanks,
-Ron
-
"Sort By:" at bottom of page (reply)
Ron,
Try using AS is your SQL statement, like this:
dbSQL = "Select lngCatalogID AS Catalog_ID_# From tablename"
You can still do a dbNameMap if you want to change it further, but I 'think' that this technique will change the statusbar shown below the grid. Oh, forget it. Example 21b shows it won't work.
Of course, you can always set dbstatusbar=false and design your own status bar. see example 1b at http://www.aspdb.com/apps
Did you ever get the sort = Descending flag to work OK?
Mark.
------------
Ron Critchfield at 9/20/00 3:51:33 AM
First of all I want to thank everyone who has been answering all of my questions. Especially Mark.
When I click on a hot column to sort, I get something like this at the bottom of the screen.
Sort By: [lngCatalogID] [36 - 40 : 40]
My problem is the "lngCatalogID" I've already used nmap to change "lngCatalogID" to "Catalog ID #"
I'd prefer not to have the actual field names visible to the user. Anyone know how to either get rid of the "Sort By:" line or to change the field name shown?
Thanks,
-Ron
-
"Sort By:" at bottom of page (reply)
Thanks Mark,
I haven't quite gotten the descending flag to work like I want, but I know that it can be done. Finding out that there was a session variable
Session("DIRECTION_X.dbUnit" that gets set to "DESC" when descending was crucial.
------------
Mark at 9/20/00 8:35:50 AM
Ron,
Try using AS is your SQL statement, like this:
dbSQL = "Select lngCatalogID AS Catalog_ID_# From tablename"
You can still do a dbNameMap if you want to change it further, but I 'think' that this technique will change the statusbar shown below the grid. Oh, forget it. Example 21b shows it won't work.
Of course, you can always set dbstatusbar=false and design your own status bar. see example 1b at http://www.aspdb.com/apps
Did you ever get the sort = Descending flag to work OK?
Mark.
------------
Ron Critchfield at 9/20/00 3:51:33 AM
First of all I want to thank everyone who has been answering all of my questions. Especially Mark.
When I click on a hot column to sort, I get something like this at the bottom of the screen.
Sort By: [lngCatalogID] [36 - 40 : 40]
My problem is the "lngCatalogID" I've already used nmap to change "lngCatalogID" to "Catalog ID #"
I'd prefer not to have the actual field names visible to the user. Anyone know how to either get rid of the "Sort By:" line or to change the field name shown?
Thanks,
-Ron
-
"Sort By:" at bottom of page (reply)
Weird. I tried building my own staus bar, but MyDb.dbRecordCount always = 0. The status bar is finding a count, I can't figure out why MyDb.dbRecordCount can't.
-Ron
------------
Mark at 9/20/00 8:35:50 AM
Ron,
Try using AS is your SQL statement, like this:
dbSQL = "Select lngCatalogID AS Catalog_ID_# From tablename"
You can still do a dbNameMap if you want to change it further, but I 'think' that this technique will change the statusbar shown below the grid. Oh, forget it. Example 21b shows it won't work.
Of course, you can always set dbstatusbar=false and design your own status bar. see example 1b at http://www.aspdb.com/apps
Did you ever get the sort = Descending flag to work OK?
Mark.
------------
Ron Critchfield at 9/20/00 3:51:33 AM
First of all I want to thank everyone who has been answering all of my questions. Especially Mark.
When I click on a hot column to sort, I get something like this at the bottom of the screen.
Sort By: [lngCatalogID] [36 - 40 : 40]
My problem is the "lngCatalogID" I've already used nmap to change "lngCatalogID" to "Catalog ID #"
I'd prefer not to have the actual field names visible to the user. Anyone know how to either get rid of the "Sort By:" line or to change the field name shown?
Thanks,
-Ron
-
"Sort By:" at bottom of page (reply)
Not sure why this worked, but it solved the problem. Since I only have the one database, I wasn't setting "dbUnit". I went back and set "dbUnit" and now it works. Weird.
-Ron
------------
Mark at 9/21/00 9:39:24 AM
Ron,
It sounds like you have a bug in your code.
Show us your code.
See Example 1b at http://www.aspdb.com/apps
Mark.
------------
Ron Critchfield at 9/21/00 4:45:56 AM
Weird. I tried building my own staus bar, but MyDb.dbRecordCount always = 0. The status bar is finding a count, I can't figure out why MyDb.dbRecordCount can't.
-Ron
------------
Mark at 9/20/00 8:35:50 AM
Ron,
Try using AS is your SQL statement, like this:
dbSQL = "Select lngCatalogID AS Catalog_ID_# From tablename"
You can still do a dbNameMap if you want to change it further, but I 'think' that this technique will change the statusbar shown below the grid. Oh, forget it. Example 21b shows it won't work.
Of course, you can always set dbstatusbar=false and design your own status bar. see example 1b at http://www.aspdb.com/apps
Did you ever get the sort = Descending flag to work OK?
Mark.
------------
Ron Critchfield at 9/20/00 3:51:33 AM
First of all I want to thank everyone who has been answering all of my questions. Especially Mark.
When I click on a hot column to sort, I get something like this at the bottom of the screen.
Sort By: [lngCatalogID] [36 - 40 : 40]
My problem is the "lngCatalogID" I've already used nmap to change "lngCatalogID" to "Catalog ID #"
I'd prefer not to have the actual field names visible to the user. Anyone know how to either get rid of the "Sort By:" line or to change the field name shown?
Thanks,
-Ron
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|